| AmOnlineApplicant |
| Logical Entity Name | AmOnlineApplicant |
| Default Table Name | AmOnlineApplicant |
| Physical Only | NO |
| Definition | |
| Note |
| AmOnlineApplicant Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| WpUserID | int | NO | ||
| WebUserName | char(128) | NO | ||
| LastName | varchar(25) | NO | ||
| FirstName | varchar(25) | NO | ||
| MiddleName | varchar(100) | YES | ||
| SSN | char(16) | YES | ||
| Address | varchar(255) | NO | ||
| City | char(25) | NO | ||
| State | char(2) | NO | ||
| Zip | char(10) | NO | ||
| SyCountryID | int | NO | ||
| Phone | char(16) | NO | ||
| WorkPhone | char(16) | YES | ||
| WorkExt | varchar(10) | NO | ||
| OtherPhone | char(16) | NO | ||
| varchar(50) | NO | |||
| OtherEmail | varchar(50) | YES | ||
| PermAddress | varchar(255) | YES | ||
| PermCity | char(25) | YES | ||
| PermState | char(2) | YES | ||
| PermZip | char(10) | YES | ||
| PermSyCountryID | int | YES | ||
| PermPhone | char(16) | YES | ||
| AmLeadSrcID | int | NO | ||
| AmRepID | int | YES | ||
| AmApplicantTypeID | int | YES | ||
| CitizenID | int | YES | ||
| AlienNo | char(9) | YES | ||
| DrivLic | char(20) | YES | ||
| DrivLicState | char(2) | YES | ||
| MaritalID | int | YES | ||
| DOB | datetime | YES | ||
| SexID | int | YES | ||
| RaceID | int | YES | ||
| CampusID | int | YES | ||
| DegreeID | int | YES | ||
| ProgramID | int | YES | ||
| ProgramVersionID | int | YES | ||
| StartDate | datetime | YES | ||
| StartDateID | int | YES | ||
| HighSchoolID | int | YES | ||
| HighSchoolGrad | datetime | YES | ||
| HighSchoolGraduated | tinyint | YES | ||
| HighSchoolGPA | numeric(11, 6) | YES | ||
| PersonalStatement | text | YES | ||
| CardTypeId | int | YES | ||
| CardNumber | varchar(500) | YES | ||
| LastFourNumber | char(4) | YES | ||
| CardExpiration | datetime | YES | ||
| CardHolderName | varchar(50) | YES | ||
| CardHolderAddr | varchar(50) | YES | ||
| CardHolderZip | varchar(15) | YES | ||
| CardHolderCity | varchar(30) | YES | ||
| CardHolderState | char(2) | YES | ||
| PaymentAmount | money | YES | ||
| Active | bit | NO | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
| HSGradYear | varchar(4) | YES | ||
| AmPrevEducID | int | YES | ||
| AmLeadTypeID | int | YES | ||
| NewLeadStatusID | int | YES | ||
| FinalStatusID | int | YES | ||
AmOnlineApplicantID |
int | NO | ||
AmTitleID |
int | YES | ||
| ApplicationProgress | int | NO | ||
| ConcentrationList | ntext | NO | ||
| IsDuplicate | bit | NO | ||
| IsNewLeadApplicant | bit | NO | ||
| SyStudentID | int | NO | ||
| CardHolderFirstname | varchar(50) | NO | ||
| CardHolderLastname | varchar(50) | NO | ||
| MobileNumber | char(16) | YES | ||
CMSMSServiceProviderID |
int | YES | ||
| SubscribeToSMS | bit | NO | ||
| AmGradeLevelId | int | YES | ||
| GEDAwardedDate | datetime | YES | ||
| IsHispanic | char(1) | YES | ||
| CCAuthNum | char(10) | YES | ||
| CoRelationId | nvarchar(20) | YES | ||
| BankName | char(10) | YES | ||
| BankRoutingNumber | char(10) | YES | ||
| BankAccountNumber | char(10) | YES | ||
| BankAccountTypeCode | char(10) | YES | ||
| BankAuthorizationNumber | char(10) | YES | ||
| PaymentGatewayProvider | char(10) | YES | ||
| BankIV | char(10) | YES | ||
| BankAccountActive | char(10) | YES |
| AmOnlineApplicant Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_AmOnlineApplicant_AmOnlineApplicantID | PrimaryKey | AmOnlineApplicantID |
| AmOnlineApplicant Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| SyStaff | Non-Identifying | One To Zero or More | FK_AmOnlineApplicant.UserID_SyStaff.SyStaffID | UserID | NO | YES | ||
| amTitle | Non-Identifying | Zero or One to Zero or More | FK_AmOnlineApplicant_AmTitleID_AmTitle_AmTitleID | AmTitleID | NO | YES | ||
| CMSMSServiceProvider | Non-Identifying | Zero or One to Zero or More | FK_AmOnlineApplicant_CMSMSServiceProviderID_CMSMSServiceProvider_CMSMSServiceProviderID | CMSMSServiceProviderID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| AmOnlineApplicantAmRace | Non-Identifying | One To Zero or More | FK_AmOnlineApplicantAmRaceAmOnlineApplicantID_AmOnlineApplicantAmOnlineApplicantID | NO | YES | |||
| AmOnlineApplicantStatChange | Non-Identifying | One To Zero or More | FK_AmOnlineApplicantStatChange_AmOnlineApplicantID_AmOnlineApplicant_AmOnlineApplicantID | NO | YES | |||
| AmOnlineApplicantSyPersonGenderPronoun | Non-Identifying | One To Zero or More | FK_AmOnlineApplicantSyPersonGenderPronoun_AmOnlineApplicantID_AmOnlineApplicant_AmOnlineApplicantID | NO | YES | |||
| AmOnlineApplicantUserValues | Non-Identifying | One To Zero or More | FK_AmOnlineApplicantUserValuesAmOnlineApplicantID_AmOnlineApplicantAmOnlineApplicantID | NO | YES |
| AmOnlineApplicant Check Constraints |
| Check Constraint Name | CheckConstraint |